package com.be.beadmin.material.entity;

import com.be.beadmin.common.entity.BaseEntity;
import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import java.util.Date;

/**
 * @Author: Mengyang Zhu
 * @Date: 2023/5/8 11:11
 * @Description: PurchaseOrderTotal
 */

@Entity
@Data
@Table(name = "V_MM_PurchaseOrder")
public class PurchaseOrderTotal extends BaseEntity {


    //来自PurchaseOrder
    @Column(name = "erpOrderNo", columnDefinition = "VARCHAR(50) COMMENT 'ERP任务号' ")
    private String erpOrderNo;
    @Column(name = "So", columnDefinition = "VARCHAR(50) COMMENT '销售订单号' ")
    private String So;
    @Column(name = "SoItem", columnDefinition = "VARCHAR(50) COMMENT '销售订单行' ")
    private String SoItem;
    @Column(name = "ProjectName", columnDefinition = "VARCHAR(100) COMMENT '项目名称' ")
    private String ProjectName;
    @Column(name = "infoId", columnDefinition = "VARCHAR(100) COMMENT '项目id' ")
    private String infoId;
    @Column(name = "Po", columnDefinition = "VARCHAR(50) COMMENT '采购单号' ")
    private String Po;
    @Column(name = "PurchaseTime", columnDefinition = "datetime COMMENT '采购时间' ")
    private Date PurchaseTime;
    @Column(name = "deliveryDate", columnDefinition = "datetime COMMENT '到货日期' ")
    private Date deliveryDate;
    @Column(name = "sendDate", columnDefinition = "datetime COMMENT '发货日期' ")
    private Date sendDate;
    @Column(name="purchaseEndDate",columnDefinition = "datetime COMMENT '实际到货日期' ")
    private Date purchaseEndDate;
    @Column(name = "kickoffDate", columnDefinition = "datetime COMMENT '开工日期' ")
    private Date kickoffDate;
    @Column(name = "supplier", columnDefinition = "VARCHAR(50) COMMENT '供应商名称' ")
    private String supplier;
    @Column(name = "purchaser", columnDefinition = "VARCHAR(50) COMMENT '采购员' ")
    private String purchaser;
    @Column(name = "purchaseAlerts", columnDefinition = "VARCHAR(1) COMMENT '采购预警' ")
    private String purchaseAlerts;
    @Column(name = "poState", columnDefinition = "VARCHAR(1) COMMENT '订单状态' ")
    private String poState;
    @Column(name = "isAudit", columnDefinition = "VARCHAR(1) COMMENT '审核标志' ")
    private String isAudit;
    @Column(name = "isClosed", columnDefinition = "VARCHAR(1) COMMENT '是否全部到货' ")
    private String isClosed;
    @Column(name = "memo", columnDefinition = "text COMMENT 'order备注' ")
    private String memo;
    @Column(name = "isShort",columnDefinition = "VARCHAR(1) default 0 COMMENT '是否缺件'")
    private String isShort;

    //来自PurchaseOrderDetail
    @Column(name = "poIdentification", columnDefinition = "VARCHAR(50) COMMENT '采购订单唯一标识' ")
    private String poIdentification;
    @Column(name = "PoItem", columnDefinition = "VARCHAR(50) COMMENT '采购订单行' ")
    private String PoItem;
    @Column(name = "MaterialCode", columnDefinition = "VARCHAR(50) COMMENT '物料编码' ")
    private String MaterialCode;
    @Column(name = "MaterialName", columnDefinition = "VARCHAR(50) COMMENT '物料名称' ")
    private String MaterialName;
    @Column(name = "MaterialType", columnDefinition = "VARCHAR(50) COMMENT '物料类型' ")
    private String MaterialType;
    @Column(name = "MaterialQty", columnDefinition = "int COMMENT '物料数量' ")
    private String MaterialQty;
    @Column(name = "MaterialDesc", columnDefinition = "VARCHAR(200) COMMENT '物料描述' ")
    private String MaterialDesc;
    @Column(name = "MaterialSpec", columnDefinition = "VARCHAR(50) COMMENT '物料规格' ")
    private String MaterialSpec;
    @Column(name = "Brand", columnDefinition = "VARCHAR(50) COMMENT '品牌' ")
    private String Brand;
    @Column(name = "Unit", columnDefinition = "VARCHAR(50) COMMENT '单位' ")
    private String Unit;
    @Column(name = "UndeliveredQty", columnDefinition = "int COMMENT '未交货数量' ")
    private int UndeliveredQty;
    @Column(name = "IsFinished", columnDefinition = "VARCHAR(1) COMMENT '行业务是否关闭' ")
    private String IsFinished;
    @Column(name = "ExpectedDeliveryTime", columnDefinition = "datetime COMMENT '预计到货日期' ")
    private Date ExpectedDeliveryTime;







}
